CREATE EXTERNAL TABLE IF NOT EXISTS jms_ods.lq_self_pickup_status(
id                                                 bigint                         COMMENT '',
version                                            Double                         COMMENT '',
createtime                                         String                         COMMENT '',
lastupdatetime                                     String                         COMMENT '',
serviceSiteCode                                    String                         COMMENT '',
serviceSiteName                                    String                         COMMENT '',
collectTime                                        String                         COMMENT '',
billTotal                                          bigint                         COMMENT '',
waitStorage                                        bigint                         COMMENT '',
doingStorage                                       bigint                         COMMENT '',
waitTake                                           bigint                         COMMENT '',
retention                                          bigint                         COMMENT '',
hasTake                                            bigint                         COMMENT '',
customerReject                                     bigint                         COMMENT '',
spCode                                             String                         COMMENT '',
spName                                             String                         COMMENT '',
expressCompanyCode                                 String                         COMMENT '',
expressCompanyName                                 String                         COMMENT ''
)
COMMENT ''
PARTITIONED BY (dt STRING COMMENT '更新/创建日期 (yyyy-MM-dd)')
STORED AS PARQUET
LOCATION '/dw/hive/jms_ods.db/external/lq_self_pickup_status'
TBLPROPERTIES (
  'parquet.column.index.access'='true'
);